Originally by: Satis Iqulenax

---

Dragonaire did you read this ??

Originally by: Satis Iqulenax

---

Dragonaire I have an question to the AssetList table.

I notised that there it a rowname caled: "lft" and "rgt"

When I looked in the XML AssetList they was not mentioned in there.
Has that somthing to do with the Child of a container or the fitting on a ship ??

If so... can you give a little explanation on how those numbers are working together.

Kind Regards
Satis

---

Waiting for an answer


Kind Regards
Satis

---

Originally by: Buzz AU

---

Is that to say, we shouldn't run it using a normal cron job?

---

Originally by: Nick Partridge

---

Just wondered, I had a problem on my server and had to reinstall yapeal.

However now I keep getting the error
Failed
map.xml file was not found
or a bad XML file

I have tried to svn download, copy and paste the file etc, but it continues with same error.

Any ideas ?

---

Originally by: Nick Partridge

---

Yup it is there.
I tried to replace it witha fresh download.
I opened the file deleted contents and filled it with the online file in yapeals downloads.

Tried restoring an old version on the PC.

All still have same error.
:-(

---

Originally by: Phaedriel

---

Okay, I manually changed the names. As you say, I think it's a windows issue. I installed it on my local server and pretty much just copied it to my live server and exported/imported the SQL (yea, bad habit but it works most of the time!).

Just wanting to confirm the the message I'm getting means that all is okay (if so I'll disable the message).

Notice: Yapeal version 803 (beta) 2009-07-16 15:31:27 in (path)/httpdocs/Yapeal/inc/common_backend.php on line 54

(I editted (path) for security reasons but it's the path to the file.

If this is all good then I have to move onto Phase 2 of my application (not for public release, designed with myself and close friends in mind, just a useful tool)

---

Originally by: Sable Blitzmann

---

Edited by: Sable Blitzmann on 28/08/2009 04:51:44
I'm still playing around with it. I finally got cURL working on my server so I've been testing a lot of things out. Question: the corp stuff only works if you are the CEO of said corp, correct? Because I put in my characters info AND my corps info into the appropriate util* tables, yet when I go to run yapeal.php, it returns errors.

I assume then that I must be CEO of that corp or have some sort of role (of which I do not have...), thus making the corp API's useless to regular corp members...

---

Originally by: Sable Blitzmann

---

Do the character APIs export the characters role in his or her corp so that I can use that to narrow down what options are available for that character? For example, if a regular corp member without roles registered on the site, I do not want to insert anything into the utilRegisteredCorp table. If the corp accountant registers, I only want to enter into the `activeapi` column the API's that character can access.

---

Originally by: Sable Blitzmann

---

Also, how does yapeal handle character deletions and role removals? If a character was removed from a role, will yapeal update the database to reflect this?

---

Originally by: Elnar Khad

---

Let me say, thank you to everyone who has worked on this project. It is very well thought out and will be very useful.
I'm coming up against a wall during setup of the scripts. I have followed the windows version of the setup and most things seem to be working. It is correctly pulling down server, map and alliance information, and pulling the characters out of my accounts correctly. The only things that are not getting put into the database are the items that I put into the "ActiveAPI" fields in the utilregisteredcharacter and utilregisteredcorporation tables. Per the instructions, it should be "char" or "corp" and then the name of the api, so I'm putting in items like:

Quote:

---

charAccountBalance charAssetList charCharacterSheet charIndustryJobs charKillLog charMarketOrders charSkillInTraining charSkillQueue charStandings charWalletJournal charWalletTransactions corpAccountBalance corpAssetList corpCorporationSheet corpDivisions corpWalletDivisions corpLogo corpIndustryJobs corpKillLog corpAttackers corpItems corpVictim corpMarketOrders corpMemberTracking corpStandings corpStarbaseDetail corpCombatSettings corpFuel corpGeneralSettings corpStarbaseList corpWalletJournal corpWalletTransactions

---

I am not seeing any errors in the logs, and the yapeal/cache/char and corp folders are not getting xml documents.

I've been staring at this for days and I don't see what I'm doing wrong. Any ideas?
Thanks,
Elnar

---

Originally by: Dragonaire

---

The peak memory use is nothing to worry about that is just there as it says as a notice. If you ever see one larger than about 12 MB do let me know as I've been trying to reduce that and in my testing it's not going over about 12 MB now.

Do you see a record in the charAccountBalance table? If not then there might be a problem. First make sure you've activated that API both in the utilSections->char->activeAPI setting and in the utilRegisteredCharacter. You might also try deleting the record and see if it reappears if it does it's being updated but the API isn't changing which is an issue for CCP to solve

---

Originally by: Scribbly

---

Originally by: Dragonaire

---

For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table.

---

Do you know if any of these dump table names would clash with Yapeal? Would like to know so I can import it all into the same database to keep the complexities of the queries down

---

Originally by: Zebullon

---

I have the same problem as ChriztaneE and I can't resolve it...
The problem is certainly with the date or the release version...

The error message when I run the yapeal.php:
Notice: Yapeal version 898 (beta) 2009-09-21 18:06:41 in xxx\inc\common_backend.php on line 62

---

Originally by: ChillingEchos

---

Was wondering if anyone happened to have the solution to working around the killLogs flag field being set to zero except when its drones or cargo bay?

Found in :
/char/KillLog.xml.aspx

Results :
<rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed">
<row typeID="3520" flag="0" qtyDropped="3" qtyDestroyed="1" />
<row typeID="12076" flag="0" qtyDropped="0" qtyDestroyed="1">
<rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed">
<row typeID="12259" flag="0" qtyDropped="0" qtyDestroyed="1" />
<row typeID="1236" flag="0" qtyDropped="2" qtyDestroyed="1" />
<row typeID="2032" flag="0" qtyDropped="1" qtyDestroyed="1" />
</rowset>

Notice how all the flags are 0. in the more broad list there are only flag number 87 and 5 of which are drones and cargo bay items.

---

Originally by: ChillingEchos

---

While I'm at it. The yapeal sql for kill data uses the 'lft' 'lvl' 'rgt' fields to show the items. I may need to see if anyone can help me understand the intended use. I really cant help but to think that I may be having a glitch in my Yapeal install cause there are no "apparent" order to the results a couple will be ok and right in terms of how they were fitted on the ship then viola, gets scattered all over the place.

---

Originally by: KtoJest

---

thanx for the response.

topic: no corp data download

phpinfo():
PHP Version 5.3.1RC3-dev

phpinfo() - Date
Default timezone Europe/Berlin
(i've used the timezone function in some of my own coding so it seems to be installed)

yapeal db: activeapi field in corp record: AccountBalance AssetList MarketOrders WalletJournal WalletTransactions

where do i go from here?

---

Originally by: Strombizzle

---

I have Yapeal running under my Godaddy hosting account. It's shared hosting so I have to make due with what I have.

I set up the cronjob and here is the response I got:

/web/cgi-bin/php5: Symbol `client_errors' has different size in shared object, consider re-linking
Content-type: text/html

#!/usr/bin/php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http:www.w3.org/TR/xhtml1" xml:lang="en" lang="en">
<head>
<title>Yapeal is not a web application</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
</head>
<body>
<h1 style="font-size: xx-large;color: #ff1010;">USER ERROR USER ERROR USER ERROR</h1>
<p>
If you are seeing this you have tried to run Yapeal as a web page which is
incorrect.
Yapeal is made to <b>ONLY</b> ran from the command line.
See the <a href="https://eve-search.com/externalLink.asp?l=http%3A%2F%2Fcode%2Egoogle%2Ecom%2Fp%2Fyapeal%2Fw%2Flist">Yapeal Wiki</a> for
more information on using it.
</p>
</body>
</html>

It seems to be giving me a php library error along with the message saying that I'm running the file from the web browser.

Has anyone encountered this before? Any easy fix in the config or is this something I'm going to need to take up with godaddy?

Thanks!

---

Originally by: Cory Sopapilla

---

I don't see anything for mapJumps, mapKills, Soverignty, etc and it's listed as working on the wiki.

---

Originally by: Qoi

---

Hey Dragonaire, thanks for your great library (I've been using it for quite some time now).
I like to keep my yapeal up to date with svn (as i think that's way easier than any installer/whatever stuff), however there are some files that are under version control but keep getting changed by the library itself, namely:
M log/yapeal_warning.log
M log/yapeal_strict.log
M log/yapeal_error.log
M log/yapeal_trace.log
M log/yapeal_notice.log

which makes it very impractical to use svn diff on my working copy.
I tried svn:ignore and deleting them (which sort of fixes the issue), but could you perhaps remove them from version control? If anyone else tries to commit something, it's not a good idea to have his logs with all the API Keys under version control, i think ;)

Keep on the great work, i'll read your blog now

---

Originally by: Dragonaire

---

Ok now that you know about svn export I may have fixed Yapeal so you don't need it there are of course the other benefits still.

After looking at it I've decided I could remove the logs from the SVN and while I was at it I fixed revision.php as well. I thought that had already been done a while back when I noticed it be apparently it didn't get changed.

To also help with the extra emails you can try adding the follow line as the first one in your crontab:
MAILTO=""
That should silent any crontab emails in most Linux distros.

---

*/60 * * * * /path/to/yapeal/yapeal.php &> /dev/null

Originally by: Gracelia

---

Installs just fine and got set up with the database. However when I try to run yapeal.php from the command line I get this

"Notice: Yapeal version 1043 (beta) 2010-04-05 00:38:06 in /home/matt/Yapeal/inc/common_backend.php on line 80"

---

Originally by: Busty Crumpet

---

Hello, I've managed to get the database and tables installed from the command line, but can't for the life of me figure out where the user apis are added to make yapeal work. I'm wondering if those wiki pages were removed as you mentioned earlier. I've given it a couple of hours reading and surfing about but reached a dead end. Any advice appreciated!

---

Originally by: Kalrand

---

Originally by: Dragonaire

---

Those scripts expect the same XML you'd get from the API for accountCharacters. They were made to be used with the installer I had been using which could grab one simple API like that then pass it off to them to work with. They also need updated now to work with changes I made that moved graphics over to new table.

---

Thanks, I assumed it had to be something like that.

---

Originally by: Arnakoz

---

Hi there, I'm running this on a Mac 10.6.6 with XAMPP.

i got into phpMyAdmin and created a db called yapeal and a user for it. but on running

php -f install/testForMySQLDatabasePrivs.php localhost <user> <pw> yapeal

i get

Connection error (2002) No such file or directory


i tried adding mysql.default_socket = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock" to /Applications/XAMPP/xamppfiles/etc/php.ini and restarting apache/mySQL ... but no go...

any ideas?

---

Originally by: CTapocTAevp

---

Pls show me any project site for use Pheal =)

---

Originally by: Rottw Adleweh

---

I'm currently experiencing some problems with r1171. The wallet transactions don't seem to get fetched and I see this message in the logs:

Quote:

---

WARNING: Row has extra unknown fields (journalTransactionID) that will be ignored for corpWalletTransactions
File: /Library/Yapeal/class/YapealQueryBuilder.php(191)

---

Although to my interpretation of the message my transactions should still be written to the database.

---

Originally by: Rottw Adleweh

---

Plus:

Quote:

---

WARNING: API connection error: Operation too slow. Less than 10 bytes/sec transfered the last 12 seconds
HTML error for API http://api.eveonline.com/eve/ConquerableStationList.xml.aspx
File: /Library/Yapeal/class/YapealNetworkConnection.php(93)

---

And finally very often:

Quote:

---

WARNING: API connection error: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol

---

Does anyone has an idea what the problem is and if it's fixable?

---

Originally by: Fredrick Engly

---

Edited by: Fredrick Engly on 09/07/2011 16:33:42
Now getting
WARNING: Caching invalid API XML for char/WalletTransactions
File: /blah/class/YapealApiCache.php(177)

and
WARNING: Caching invalid API XML for corp/WalletTransactions
File: /blah/class/YapealApiCache.php(177)

Can send files if needed

---

Originally by: Zaine Maltis

---

Edited by: Zaine Maltis on 19/08/2011 20:33:32
Yo, this looks pretty sweet. I've had a browse of your documentation and it seems like this doesn't support https://api.eveonline.com/char/UpcomingCalendarEvents.xml.aspx yet?

Am I just blind? If not, are you planning to add it?

---

Originally by: Dragonaire

---

Quote:

---

That one looks like it wouldn't be too hard to add, its counterpart, tad more of a challenge. Atm I'm working on adding contracts. Dragonaire suckered me into it.

---

Your idea to help plus it's been 3 different APIs you said you do before you finally did one before I give up on you doing it

---

Originally by: Zaepho

---

Anybody have some experience with the updated version that they want to share?

I'm sure we won't see a ton until the official switch over (I know that's when I'm planning to start frantically working on it at least) but would love to hear of any gotchas and such.

I'm also very interested in any conversion possibilities from a live DB from the old keys to the new key system, or should I ditch my tables and start fresh?

---